Hệ thống quản lý chứng khoán Dự án Java

19.539 lượt xem;
1 -- phpMyAdmin SQL Dump
2 -- version 2.11.6
3 -- http://www.phpmyadmin.net
4 --
5 -- Host: localhost
6 -- Generation Time: May 11, 2010 at 05:00 AM
7 -- Server version: 5.0.51
8 -- PHP Version: 5.2.6
9
10 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11
12
13 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16 /*!40101 SET NAMES utf8 */;
17
18 --
19 -- Database: `stock`
20 --
21
22 -- --------------------------------------------------------
23
24 --
25 -- Table structure for table `category_details`
26 --
27
28 CREATE TABLE `category_details` (
29   `id` int(10) unsigned NOT NULL auto_increment,
30   `category_name` varchar(120) NOT NULL,
31   `category_description` varchar(250) NOT NULL,
32   PRIMARY KEY (`id`)
33 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;
34
35 --
36 -- Dumping data for table `category_details`
37 --
38
39 INSERT INTO `category_details` (`id`, `category_name`, `category_description`) VALUES
40 (5, 'category1', ''),
41 (6, 'category2', ''),
42 (7, 'category3', ''),
43 (8, 'category4', ''),
44 (9, 'category6', ''),
45 (10, 'category7', ''),
46 (11, 'category8', ''),
47 (12, 'category9', ''),
48 (13, 'category10', ''),
49 (14, 'category11', ''),
50 (15, 'category18', ''),
51 (16, '', ''),
52 (17, 'newcategory', '');
53
54 -- --------------------------------------------------------
55
56 --
57 -- Table structure for table `customer_details`
58 --
59
60 CREATE TABLE `customer_details` (
61   `id` int(10) unsigned NOT NULL auto_increment,
62   `customer_name` varchar(200) NOT NULL,
63   `customer_address` varchar(500) NOT NULL,
64   `customer_contact1` varchar(100) NOT NULL,
65   `customer_contact2` varchar(100) NOT NULL,
66   `balance` int(11) NOT NULL,
67   PRIMARY KEY (`id`)
68 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
69
70 --
71 -- Dumping data for table `customer_details`
72 --
73
74 INSERT INTO `customer_details` (`id`, `customer_name`, `customer_address`, `customer_contact1`, `customer_contact2`, `balance`) VALUES
75 (1, 'Customer1', 'address1', '8523544', '75254552', 7788),
76 (2, 'customer2', 'customer 2 address', '86789789', '9879889789', 0);
77
78 -- --------------------------------------------------------
79
80 --
81 -- Table structure for table `stock_avail`
82 --
83
84 CREATE TABLE `stock_avail` (
85   `id` int(10) unsigned NOT NULL auto_increment,
86   `name` varchar(120) NOT NULL,
87   `quantity` int(10) unsigned NOT NULL,
88   PRIMARY KEY (`id`)
89 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;
90
91 --
92 -- Dumping data for table `stock_avail`
93 --
94
95 INSERT INTO `stock_avail` (`id`, `name`, `quantity`) VALUES
96 (1, 'truzo super', 0),
97 (2, 'alanto', 0),
98 (3, 'Swipe 60 GM', 0),
99 (4, 'Swipe 120 GM', 100);
100
101 -- --------------------------------------------------------
102
103 --
104 -- Table structure for table `stock_details`
105 --
106
107 CREATE TABLE `stock_details` (
108   `id` int(10) unsigned NOT NULL auto_increment,
109   `stock_id` varchar(120) NOT NULL,
110   `stock_name` varchar(120) NOT NULL,
111   `stock_quatity` int(11) NOT NULL,
112   `supplier_id` varchar(250) NOT NULL,
113   `company_price` decimal(10,2) NOT NULL,
114   `selling_price` decimal(10,2) NOT NULL,
115   `category` varchar(120) NOT NULL,
116   `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
117   `expire_date` datetime NOT NULL,
118   `uom` varchar(120) NOT NULL,
119   PRIMARY KEY (`id`)
120 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
121
122 --
123 -- Dumping data for table `stock_details`
124 --
125
126 INSERT INTO `stock_details` (`id`, `stock_id`, `stock_name`, `stock_quatity`, `supplier_id`, `company_price`, `selling_price`, `category`, `date`, `expire_date`, `uom`) VALUES
127 (1, 'SD1', 'Swipe 60 GM', 0, 'Biotic life science', '77.00', '80.00', '', '2010-04-22 16:31:10', '0000-00-00 00:00:00', '');
128
129 -- --------------------------------------------------------
130
131 --
132 -- Table structure for table `stock_entries`
133 --
134
135 CREATE TABLE `stock_entries` (
136   `id` int(10) unsigned NOT NULL auto_increment,
137   `stock_id` varchar(120) NOT NULL,
138   `stock_name` varchar(260) NOT NULL,
139   `stock_supplier_name` varchar(200) NOT NULL,
140   `category` varchar(120) NOT NULL,
141   `quantity` int(11) NOT NULL,
142   `company_price` decimal(10,2) NOT NULL,
143   `selling_price` decimal(10,2) NOT NULL,
144   `opening_stock` int(11) NOT NULL,
145   `closing_stock` int(11) NOT NULL,
146   `date` datetime NOT NULL,
147   `username` varchar(120) NOT NULL,
148   `type` varchar(50) NOT NULL,
149   `salesid` varchar(120) NOT NULL,
150   `total` decimal(10,2) NOT NULL,
151   `payment` decimal(10,2) NOT NULL,
152   `balance` decimal(10,2) NOT NULL,
153   `mode` varchar(150) NOT NULL,
154   `description` varchar(500) NOT NULL,
155   `due` datetime NOT NULL,
156   `subtotal` int(11) NOT NULL,
157   `count1` int(11) NOT NULL,
158   `billnumber` varchar(120) NOT NULL,
159   PRIMARY KEY (`id`)
160 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=193 ;
161
162 --
163 -- Dumping data for table `stock_entries`
164 --
165
166 INSERT INTO `stock_entries` (`id`, `stock_id`, `stock_name`, `stock_supplier_name`, `category`, `quantity`, `company_price`, `selling_price`, `opening_stock`, `closing_stock`, `date`, `username`, `type`, `salesid`, `total`, `payment`, `balance`, `mode`, `description`, `due`, `subtotal`, `count1`, `billnumber`) VALUES
167 (141, 'SA1', 'stock67', '', '', 34, '0.00', '0.00', 770, 736, '2010-03-11 00:00:00', 'admin', 'sales', 'SA1', '15572.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
168 (142, 'SA1', 'stock673', '', '', 34, '0.00', '0.00', 6773, 6739, '2010-03-11 00:00:00', 'admin', 'sales', 'SA1', '42330.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
169 (143, 'SA58', 'stock673', '', '', 34, '0.00', '0.00', 6739, 6705, '2010-03-11 00:00:00', 'admin', 'sales', 'SA58', '42330.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
170 (144, 'SA58', 'stock56', '', '', 34, '0.00', '0.00', 1905, 1871, '2010-03-11 00:00:00', 'admin', 'sales', 'SA58', '2652.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
171 (145, 'SA58', 'stock67', '', '', 34, '0.00', '0.00', 736, 702, '2010-03-11 00:00:00', 'admin', 'sales', 'SA58', '15572.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
172 (161, 'SA61', 'stock67', '', '', 34, '0.00', '0.00', 722, 688, '2010-03-11 00:00:00', 'admin', 'sales', 'SA61', '15572.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
173 (162, 'SA61', 'stock56', '', '', 34, '0.00', '0.00', 1664, 1630, '2010-03-11 00:00:00', 'admin', 'sales', 'SA61', '2652.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
174 (163, 'SA61', 'stock673', '', '', 34, '0.00', '0.00', 6626, 6592, '2010-03-11 00:00:00', 'admin', 'sales', 'SA61', '42330.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
175 (164, 'SA64', 'sdkfjsf', '', '', 34, '0.00', '0.00', 48268, 48234, '2010-03-11 00:00:00', 'admin', 'sales', 'SA64', '3060.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
176 (165, 'SA64', 'stock56', '', '', 34, '0.00', '0.00', 1630, 1596, '2010-03-11 00:00:00', 'admin', 'sales', 'SA64', '2652.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
177 (166, 'SA64', 'sdkfjsf', '', '', 34, '0.00', '0.00', 48234, 48200, '2010-03-11 00:00:00', 'admin', 'sales', 'SA64', '3060.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
178 (167, 'SA64', 'stock56', '', '', 34, '0.00', '0.00', 1596, 1562, '2010-03-11 00:00:00', 'admin', 'sales', 'SA64', '2652.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
179 (168, 'SA64', 'sdkfjsf', '', '', 34, '0.00', '0.00', 48200, 48166, '2010-03-11 00:00:00', 'admin', 'sales', 'SA64', '3060.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
180 (169, 'SA64', 'stock56', '', '', 34, '0.00', '0.00', 1562, 1528, '2010-03-11 00:00:00', 'admin', 'sales', 'SA64', '2652.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
181 (170, 'SA64', 'sdkfjsf', '', '', 34, '0.00', '0.00', 48166, 48132, '2010-03-11 00:00:00', 'admin', 'sales', 'SA64', '3060.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
182 (171, 'SA64', 'stock56', '', '', 34, '0.00', '0.00', 1528, 1494, '2010-03-11 00:00:00', 'admin', 'sales', 'SA64', '2652.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
183 (172, 'SA64', 'sdkfjsf', '', '', 34, '0.00', '0.00', 48132, 48098, '2010-03-11 00:00:00', 'admin', 'sales', 'SA64', '3060.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
184 (173, 'SA64', 'stock56', '', '', 34, '0.00', '0.00', 1494, 1460, '2010-03-11 00:00:00', 'admin', 'sales', 'SA64', '2652.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
185 (174, 'SA64', 'sdkfjsf', '', '', 34, '0.00', '0.00', 48098, 48064, '2010-03-11 00:00:00', 'admin', 'sales', 'SA64', '3060.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
186 (175, 'SA64', 'stock56', '', '', 34, '0.00', '0.00', 1460, 1426, '2010-03-11 00:00:00', 'admin', 'sales', 'SA64', '2652.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
187 (182, 'SA82', 'stock67', '', '', 34, '0.00', '0.00', 722, 688, '2010-03-12 00:00:00', 'admin', 'sales', 'SA82', '15572.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
188 (183, 'SA82', 'stock673', '', '', 34, '0.00', '0.00', 6626, 6592, '2010-03-12 00:00:00', 'admin', 'sales', 'SA82', '42330.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
189 (184, 'SA82', 'stock67', '', '', 34, '0.00', '0.00', 688, 654, '2010-03-12 00:00:00', 'admin', 'sales', 'SA82', '15572.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
190 (185, 'SA82', 'stock673', '', '', 34, '0.00', '0.00', 6592, 6558, '2010-03-12 00:00:00', 'admin', 'sales', 'SA82', '42330.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
191 (186, 'SA86', 'stock673', '', '', 1, '0.00', '1245.00', 6558, 6557, '2010-03-19 00:00:00', 'admin', 'sales', 'SA86', '1245.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
192 (187, 'SA86', 'stock67', '', '', 1, '0.00', '458.00', 654, 653, '2010-03-19 00:00:00', 'admin', 'sales', 'SA86', '458.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, ''),
193 (188, 'SE188', 'Swipe 60 GM', 'Biotic life science ', '', 100, '77.00', '80.00', 100, 100, '2010-03-19 00:00:00', 'admin', 'entry', '', '7700.00', '21100.00', '0.00', 'cash', '', '2010-04-22 00:00:00', 21100, 1, '2538'),
194 (189, 'SE188', 'Swipe 120 GM', 'Biotic life science ', '', 100, '134.00', '136.00', 100, 100, '2010-03-19 00:00:00', 'admin', 'entry', '', '13400.00', '21100.00', '0.00', 'cash', '', '2010-04-22 00:00:00', 21100, 2, '2538'),
195 (191, 'SE190', 'Swipe 60 GM', 'Biotic life science', '', 14, '77.00', '80.00', 100, 114, '2010-05-11 00:00:00', 'admin', 'entry', '', '1078.00', '800.00', '278.00', 'cash', 'sdfds', '2010-05-11 00:00:00', 1078, 1, '9789'),
196 (192, 'SA1', 'swipe 60 GM', '', '', 114, '0.00', '80.00', 114, 0, '2010-05-11 00:00:00', 'admin', 'sales', 'SA1', '9120.00', '0.00', '0.00', '', '', '0000-00-00 00:00:00', 0, 0, '897897');
197
198 -- --------------------------------------------------------
199
200 --
201 -- Table structure for table `stock_sales`
202 --
203
204 CREATE TABLE `stock_sales` (
205   `id` int(10) unsigned NOT NULL auto_increment,
206   `transactionid` varchar(250) NOT NULL,
207   `stock_name` varchar(200) NOT NULL,
208   `category` varchar(120) NOT NULL,
209   `supplier_name` varchar(200) NOT NULL,
210   `selling_price` decimal(10,2) NOT NULL,
211   `quantity` decimal(10,2) NOT NULL,
212   `amount` decimal(10,2) NOT NULL,
213   `date` datetime NOT NULL,
214   `username` varchar(120) NOT NULL,
215   `customer_id` varchar(120) NOT NULL,
216   `subtotal` decimal(10,2) NOT NULL,
217   `payment` decimal(10,2) NOT NULL,
218   `balance` decimal(10,2) NOT NULL,
219   `due` datetime NOT NULL,
220   `mode` varchar(250) NOT NULL,
221   `description` varchar(500) NOT NULL,
222   `count1` int(11) NOT NULL,
223   `billnumber` varchar(120) NOT NULL,
224   PRIMARY KEY (`id`)
225 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
226
227 --
228 -- Dumping data for table `stock_sales`
229 --
230
231 INSERT INTO `stock_sales` (`id`, `transactionid`, `stock_name`, `category`, `supplier_name`, `selling_price`, `quantity`, `amount`, `date`, `username`, `customer_id`, `subtotal`, `payment`, `balance`, `due`, `mode`, `description`, `count1`, `billnumber`) VALUES
232 (2, 'SA1', 'swipe 60 GM', '', '', '80.00', '114.00', '9120.00', '2010-05-11 00:00:00', 'admin', 'customer1', '9120.00', '1452.00', '7668.00', '2010-05-11 00:00:00', 'cash', 'dsfds', 1, '897897');
233
234 -- --------------------------------------------------------
235
236 --
237 -- Table structure for table `stock_user`
238 --
239
240 CREATE TABLE `stock_user` (
241   `id` int(10) unsigned NOT NULL auto_increment,
242   `username` varchar(120) NOT NULL,
243   `password` varchar(120) NOT NULL,
244   `user_type` varchar(20) NOT NULL,
245   PRIMARY KEY (`id`)
246 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
247
248 --
249 -- Dumping data for table `stock_user`
250 --
251
252 INSERT INTO `stock_user` (`id`, `username`, `password`, `user_type`) VALUES
253 (1, 'admin', 'admin', 'admin');
254
255 -- --------------------------------------------------------
256
257 --
258 -- Table structure for table `supplier_details`
259 --
260
261 CREATE TABLE `supplier_details` (
262   `id` int(10) unsigned NOT NULL auto_increment,
263   `supplier_name` varchar(200) NOT NULL,
264   `supplier_address` varchar(500) NOT NULL,
265   `supplier_contact1` varchar(100) NOT NULL,
266   `supplier_contact2` varchar(100) NOT NULL,
267   `balance` int(11) NOT NULL,
268   PRIMARY KEY (`id`)
269 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
270
271 --
272 -- Dumping data for table `supplier_details`
273 --
274
275 INSERT INTO `supplier_details` (`id`, `supplier_name`, `supplier_address`, `supplier_contact1`, `supplier_contact2`, `balance`) VALUES
276 (1, 'Biotic life science', 'xxx', '2586633', '', 278);
277
278 -- --------------------------------------------------------
279
280 --
281 -- Table structure for table `transactions`
282 --
283
284 CREATE TABLE `transactions` (
285   `id` int(10) unsigned NOT NULL auto_increment,
286   `type` varchar(50) NOT NULL,
287   `customer` varchar(250) NOT NULL,
288   `supplier` varchar(250) NOT NULL,
289   `subtotal` decimal(10,2) NOT NULL,
290   `payment` decimal(10,2) NOT NULL,
291   `balance` decimal(10,2) NOT NULL,
292   `due` datetime NOT NULL,
293   `date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
294   `rid` varchar(120) NOT NULL,
295   PRIMARY KEY (`id`)
296 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
297
298 --
299 -- Dumping data for table `transactions`
300 --
301
302 INSERT INTO `transactions` (`id`, `type`, `customer`, `supplier`, `subtotal`, `payment`, `balance`, `due`, `date`, `rid`) VALUES
303 (1, 'entry', '', '12455', '0.00', '0.00', '0.00', '0000-00-00 00:00:00', '2010-03-11 09:31:26', 'SE123'),
304 (2, 'entry', '', '12455', '0.00', '100.00', '900.00', '2010-03-10 00:00:00', '2010-03-11 09:39:19', 'SE125'),
305 (3, 'entry', '', '12455', '0.00', '900.00', '0.00', '2010-03-10 00:00:00', '2010-03-11 09:39:28', 'SE125'),
306 (4, 'entry', '', '12455', '6086.00', '1000.00', '86.00', '2010-03-10 00:00:00', '2010-03-11 09:42:00', 'SE132'),
307 (5, 'sales', '', '', '57902.00', '50000.00', '5902.00', '2010-03-25 00:00:00', '2010-03-12 09:43:17', 'SA82'),
308 (6, 'sales', '', '', '57902.00', '2000.00', '3902.00', '2010-03-25 00:00:00', '2010-03-12 09:43:23', 'SA82'),
309 (7, 'sales', 'customer1', '', '5712.00', '2000.00', '1712.00', '2010-03-13 00:00:00', '2010-03-12 09:45:46', 'SA64'),
310 (8, 'entry', '', '12455', '3060.00', '100.00', '960.00', '2010-03-11 00:00:00', '2010-03-21 13:16:46', 'SE155');
311
312 -- --------------------------------------------------------
313
314 --
315 -- Table structure for table `uom_details`
316 --
317
318 CREATE TABLE `uom_details` (
319   `id` int(10) unsigned zerofill NOT NULL auto_increment,
320   `name` varchar(120) NOT NULL,
321   `spec` varchar(120) NOT NULL,
322   PRIMARY KEY (`id`)
323 ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
324
325 --
326 -- Dumping data for table `uom_details`
327 --
328
329 INSERT INTO `uom_details` (`id`, `name`, `spec`) VALUES
330 (0000000006, 'UOM1', 'UOM1 Specification'),
331 (0000000007, 'UOM2', 'UOM2 Specification'),
332 (0000000008, 'UOM3', 'UOM3 Specification'),
333 (0000000009, 'UOM4', 'UOM4 Specification');


Web, Tìm kết quả nhanh

Kích thước hoặc độ phức tạp của bản gửi này, tác giả đã gửi nó dưới dạng tệp .zip để rút ngắn thời gian tải xuống của bạn. Sau khi tải xuống, bạn sẽ cần một chương trình như Winzip để giải nén nó.

Tất cả các tệp đều được codefly.vn quét mỗi ngày một lần để tìm vi-rút, nhưng vi-rút mới xuất hiện hàng ngày nên không có chương trình phòng ngừa nào có thể bắt được 100% chúng.

ĐỂ AN TOÀN CỦA CHÍNH BẠN, VUI LÒNG:

1. Quét lại các tệp đã tải xuống bằng trình kiểm tra vi-rút cá nhân của bạn trước khi sử dụng.

2. KHÔNG BAO GIỜ, chạy các tệp đã biên dịch (.exe's, .ocx's, .dll's, v.v.)--chỉ chạy code mà bạn đã xem ít nhất 1 lần.

Official Website:

https://www.codewithc.com/.....ystem-project-java/

Gõ tìm kiếm nhanh...



Dự án liên quan!

Hệ thống đặt hàng đơn giản trong mã nguồn miễn phí Java

69 lượt xem

Ứng dụng quản lý liên hệ người dùng đơn giản bằng mã nguồn miễn phí Java

69 lượt xem

Java đổi quyền truy cập

973 lượt xem

Java Từ khóa final

610 lượt xem

Java Từ khóa this

586 lượt xem

Java Toán tử instanceof

711 lượt xem